Timeouts for SSRS

Increasing the Default Timeout in New World ERP

By default the SSRS Report Server will limit report execution to 30 minutes. Any reports/forms run that process longer than 30 minutes will timeout and fail. This will cause a problem with certain SSRS reports/forms used in New World ERP when they process for longer than 30 minutes.

When dealing with SSRS reports/forms in New World ERP, there are two timeout values you will need to be aware of if timeouts occur. There is a timeout value specified on the SSRS Report Server and a value specified inside New World ERP. By default the SSRS Report Server and New World ERP are set to time out after 30 minutes. Customers who have been running earlier releases will have a New World ERP timeout value defaulted to either 5 or 15 minutes. Since this is an app setting in the web.config file, it will not be updated to 30 minutes when existing customers install the 6.1 release. Existing customers will most likely have to update the New World ERP report timeout value to at least 30 minutes to run the SSRS forms that are new in the 6.1 release.

SSRS Report Server Timeout

Timeouts probably will not occur for the majority of the reports/forms run from New World ERP. However, this change becomes imperative when a customer runs complicated forms or processes with a large amount of data, such as sub-reports; a utility bill is a good example. If a customer begins seeing reports consistently fail around 30 minutes after running the report, it may be a timeout issue. Follow the directions below to adjust the timeout so that these processes finish.

Override the global SSRS default timeout for specific reports/forms.

It is not necessary to log on to the SSRS Report Server to perform these steps. Simply log onto any Windows computer as a windows authenticated user who has the System Administrator role assigned to them on the SSRS Report Server.

Open a web browser and navigate to the report server. By default the address is http://<SSRS_REPORT_SERVER_NAME>/Reports/Pages/Folder.aspx.

Click on the folder that is named the same as the New World ERP web server. This folder contains all of the SSRS reports/forms that New World ERP uses.

Navigate to the appropriate report/form file(s), remembering that some use sub-reports as well. This step may require the help of a developer to pinpoint the correct report file(s).

When the appropriate file has been found and you have navigated to the folder containing the file, click the button near the top right of the page:

In this sample, there is one main report file and two sub-reports. It is most likely not necessary to change the timeout on the sub-reports, so only do that if you find it necessary (e.g., if the main report has an extremely large timeout—such as several days—and it is still timing out, a sub-report may be the issue. Increase the timeout on the sub-reports in this instance.). Click the Properties icon in the Edit column of the main report file (see below).

On the left-side link panel, click the Execution link on the left-hand side of the page.

Under the Report Execution Timeout heading, select the Limit report execution to the following number of seconds radio button and enter an appropriate number of seconds for the report/form to run (the correct value will vary depending on the report). This value will override the system default setting of 1800 seconds. This may require some trial and error as you try to find the appropriate timeout value, or you can set it to an hour or two so it will definitely complete.

Finally click the button at the bottom of the Execution page after setting a timeout value. This change will happen the next time the report/form is run and does not require anything to be restarted.

New World ERP Report Server Timeout

As with the Reporting Server setting there is a default New World ERP timeout setting of 1,800,000 milliseconds or 30 minutes. It is recommended that you keep the New World ERP setting and the Reporting Service setting in sync (where the New World ERP value equals the largest timeout time set on a report or the default timeout time on the SSRS Report Server, whichever is greater. In order to increase the timeout from New World ERP, please follow the directions below.

How to override the global New World ERP default timeout for SSRS reports/forms:

At this time, it is not possible to set a timeout override on specific reports/forms like it is on the SSRS Report Server. The Echo reports time out only from the stored procedure, so no override is available for Echo reports.

Updating the New World ERP timeout value will take down New World ERP during the process, so do this only after hours when there is nobody logged into the system.

On the New World ERP web server, navigate to C:\Program Files\New World Systems\New World ERP\Logos and open up the file web.config in Notepad.

Find the line <add key="ReportServerTimeout" value="1800000" />. The value may vary depending on customer and version of New World ERP.

Enter the new value (in milliseconds) for the SSRS report timeout. This value should be equal to the largest timeout override specified for a report file on the SSRS Report Server or the default SSRS Report Server value, whichever is greater. Otherwise New World ERP will time out before the SSRS Report Server does for some reports/forms.